EDA - Energy Technology RD&D Budget

This dataset has been taken from International Energy Agency

The focus of this study is explore the RD&D Budget Database, which tracks the trends in spendings made for energy technologies in the IEA countries since 1974.


We will see further as we explore our dataset.

Note: The dataset when downloaded from the IEA was in the form of .xlsx file containing columns for each year starting from 1974.
For convenience of data handling (preparation, cleaning & visualisation) the year columns have been Unpivoted using Excel's Power Query and then the required sheets were saved as CSV files.

The original xlsx file will also be available if you want to work with it directly.

There seems to be a problem! As seen in 'public_rd.head()' The Amount column does contain null values but above it shows us 0.0% null value.
Looks like it sees " .. " as values instead of null values.

To check this, lets see the dtypes of our dataset!

Great! now that we have converted Year and Amount columns, its time for some data vizzes!

Though, before we begin we need to select a currency type through which we will decide the spendings done by each country as per sectors.

It can be observed that in Public RD & D deparments most of the spendings throughout many years(1974-2020), by IEA countries, for Energy Technologies, has been done in Nuclear Sectors with an approx. of 200 million USD

Let's see which of the region have had a bigger budget for its Public RD&D energy departments.

This will be calculated using the mean of total budget allotted by a region for each year.

Interesting!

Looks like we only have 3 countries in IEA having private RD&D departments

Amount column contains 0.5 null values. Since it is less than 1% we can change to these null values to 0 without affecting our dataset.

Looks like private RD&D departments in Italy spends more than 90 million USD for Energy Technologies.

Let's see how much it differs from Italy's public RD&D

We can see that Italy's private RD & D Energy Technologies Departments has more budget allocated than the public RD's

Let's check how it compares with Sectors of public and private RD's departments of Italy

You can hover over the scattered plot to see for which year an amount was allocated to a particular sector by Public and Private RD&D departments.

Let's get our last dataset (Economic Indicators)

Here we will see :

Which are the IEA countries ?

Comparison between IEA countries by it's spendings done in Energy Technologies according to the country's GDP

As of the recent year 2020, Norway has had the most RD&D budget per thousand units of its GDP followed by Finland and Japan!

You can hover over to bars to see their exact budget per thousand units of its GDP.
You can scroll through the years to see which IEA countries has had the most total budget for Energy Techonolgoies RD&D departments.